package shop;

import common.db.*;
import common.main.*;

public class GoodsReviewListBean extends MainBean
{
	public void funcExecute() throws Exception
	{
		String gno = (String)inputTable.get("gno");

		queryBuffer = new StringBuffer("");
		queryBuffer.append("SELECT NAME, CONTENT, PASS, CODE, ");
		queryBuffer.append("TO_CHAR(REG_DATE, 'YYYY-MM-DD') REG_DATE,REG_ID FROM GOODS_REVIEW ");
		queryBuffer.append("WHERE CODE='"+gno+"' ");
		queryBuffer.append("ORDER BY SEQ ");

		DBExecute dbe = new DBExecute(queryBuffer.toString());
		outputList = dbe.getDataList();
	}
}